A temporary table is created in iMIS to handle the interaction between the REFERRAL_AREA general lookup/validation table and the Professional Referral module. The table is named #AreaZip. You can query this table, after an initial search to ensure the Zip/Area Search will be working properly.
To verify Zip/Area search feature is working properly
1. Select Utilities> SQL Query.
2. Enter the following query in the SQL Command Text area:
Select * from #AreaZip
The AREA column in the Command Results area should contain the codes you defined in the REFERRAL_AREA table. Each zip code from the Description field should display in the ZIP column individually.